Re: [GENERAL] equivalent of sqlload?

At 16:45 +0200 on 25/11/98, John Holland wrote:


> Oracle has a facility for loading in massive data files, sqlload I think
> is the name. I'd like to load some big data into PostgreSQL 6.4 for
> testing purposes. Is there a way built in or would a perl or c hack be the
> way to go?

Use the COPY command. It is preferable not to define indices (or to drop
the indices) on the table, then do the massive load with COPY, and then
define the indices.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma